﻿CREATE VIEW [acms].[UserPostVoteAverage_View]
AS 
	SELECT 
		a.PostGuid,
		AVG(a.Score) as Average,
		Count(a.Id) as Total
	FROM UserPostVote a 
	GROUP BY 		
		a.PostGuid
